create external table if not exists jms_dm.dm_scan_small_equipment_hi
(
    scan_time_dt               string comment '扫描时间yyyy-mm-dd',
    scan_time_hh               string comment '扫描时间所属小时hh',
    equipment_code             string comment '交叉带',
    supply_desk_code           string comment '供包台',
   center_code                 string comment '中心id',
   center_name                 string comment '中心',
   agent_code                  string comment '代理区id',
   agent_name                  string comment '代理区',
   inductions_num              bigint comment '供件量/操作量',

   valid_sorting_num           bigint comment '有效分拣量',
   error_num                   bigint comment '异常量',
   out_package_num             bigint comment '出港建包',
   out_sorting_num             bigint comment '出港分拣',
   in_package_num              bigint comment '进港建包',
   in_sorting_num              bigint comment '进港分拣',
   package_num                 bigint comment '建包量',
   inductions_total            bigint comment '供包台去重',
   supply_valid                bigint comment '供包台有效时长',
   equipment_valid             bigint comment '交叉带有效时长',
   center_valid                bigint comment '中心有效时长',
   agent_valid                 bigint comment '代理区有效时长',
   all_valid                   bigint comment '全国有效时长'
)
comment '智兔app交叉带数据'
partitioned by (dt string comment '扫描时间分区')
stored as parquet
location '/dw/hive/jms_dm.db/external/dm_scan_small_equipment_hi'
tblproperties (
          'discover.partitions' = 'false',
          'parquet.column.index.access' = 'true'
          );